package com.bw.mapper;
import com.bw.bean.KeyWord;
import com.bw.util.R;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface GmallMapper {
    @Select("select sum(price) from H where date = #{date}")
    String getGmv(String date);

    @Select("select kw,sum(kc) as kc from kw_table where cur_date = #{date} group by kw")
    List<KeyWord> getKeyWord(String date);
}
